Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# PLSQL_WARNINGS

Property | Description
--- | ---
Parameter type | String
Syntax | `PLSQL_WARNINGS = '``value_clause``' [, '``value_clause``' ] ...`
| value_clause::= `{ ENABLE | DISABLE | ERROR }:` `{ ALL` `| SEVERE` `| INFORMATIONAL` `| PERFORMANCE` `| {` `integer` `| (``integer` `[,` `integer` `] ...)` `}` `}`
Default value | `'DISABLE:ALL'`
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`
Examples |
    PLSQL_WARNINGS = 'ENABLE:SEVERE', 'DISABLE:INFORMATIONAL';
    PLSQL_WARNINGS = 'DISABLE:ALL';
    PLSQL_WARNINGS = 'DISABLE:5000', 'ENABLE:5001', 'ERROR:5002';
    PLSQL_WARNINGS = 'ENABLE:(5000,5001,5002)', 'DISABLE:(6000,6001)';

`PLSQL_WARNINGS` enables or disables the reporting of warning messages by the PL/SQL compiler, and specifies which warning messages to show as errors.

value_clause

Multiple value clauses may be specified, enclosed in quotes and separated by commas. Each value clause is composed of a qualifier, a colon (`:`), and a modifier.

Qualifier values:

- `ENABLE`

  Enable a specific warning or a set of warnings

- `DISABLE`

  Disable a specific warning or a set of warnings

- `ERROR`

  Treat a specific warning or a set of warnings as errors

Modifier values:

- `ALL`

  Apply the qualifier to all warning messages

- `SEVERE`

  Apply the qualifier to only those warning messages in the `SEVERE` category

- `INFORMATIONAL`

  Apply the qualifier to only those warning messages in the `INFORMATIONAL` category

- `PERFORMANCE`

  Apply the qualifier to only those warning messages in the `PERFORMANCE` category